from tortoise import BaseDBAsyncClient


async def upgrade(db: BaseDBAsyncClient) -> str:
    return """
        ALTER TABLE `jobs` ADD `posts` VARCHAR(50) NOT NULL COMMENT '负责人职位';"""


async def downgrade(db: BaseDBAsyncClient) -> str:
    return """
        ALTER TABLE `jobs` DROP COLUMN `posts`;"""
